2013-02-28 - 4994.300 - Rel Notes - Improve Error Handling in ECALC. #DotNetReleases2013
Release Notes
4994.300 - Rel Notes - Improve Error Handling in ECALC.
Admin Info
| Purpose |
4994.300 - New Process for ECALC |
| Release No# |
001 |
| Submitted on |
28/02/2013 |
| Submitted by |
Venkat_a, Rajesh_K |
| Source/Destination Systems |
Local/NEC DEV |
| Release Sent To |
Juanita Holmes |
| Objects Created By |
Venkat_a |
| Objects Tested By |
Venkat_a |
Transport and Technical Objects
| Location Objects Name |
\\10.114.165.54\sites\Deployments\BMS POLCA RELEASES\ECALC_03052013\
|
Release Notes
Please take backup of existing Stored Procedures in Dev before executing the NE_ECALC_REPORT.sql.
Create two new folders( Pending, Archive) with Read/Write permissions in the same location where the package is moved.
Change the Connection string in XML file to appropriate DB connections.
Image 1: Change New pending folder location
Image 2: Change Connection String
Schedule Ecalc.dtsx to execute after Wilcomm2Pending.dtsx every 30mins with a minimum time difference of 30 minutes.
- Wilcomm2Pending.dtsx
- Source - To Wilcomm folder(like ..\Projects\ECALC\Wilcomm\)
- Destination - To New Pending folder(like ..Projects\ECALC\Pending\)
- Ecalc.dtsx
- FilePath - To New Pending folder(like ..Projects\ECALC\Pending\)
- ArchivePath - To New Archive folder(like ..Projects\ECALC\Archive\)
- XML - To the path of XML file
Test Notes
| S.No |
Test Scenario |
Expected Results |
| 1 |
Execute the Wilcomm2Pending.dtsx package |
All the Files should be moved from wilcomm folder to pending folder with time stamp. |
| 2 |
Execute ECALC package |
Check for the files existing in pending folder, If files exists then starts the eclac process on files based on time stamp. If no error occur then all the processed files will be to archive folder and continues the process until no files exists in pending folder. If Error occur, Stop the process abnormally without processing further files. During this process,all the flow will be logged into log tables. |
Reference Document (Specifications or Production Support Break Fix)
2013-02-13 - 4994.300 - Break Fix - Improve Error Handling in ECALC.